package com.dong.dao.Provider;

import com.dong.pojo.Provider;
import com.dong.pojo.User;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface ProviderDao {
    //增加供应商
    public int add(Connection connection,Provider provider) throws SQLException;
    //通过供应商名称、编码获取供应商列表
    public List<Provider> getProviderList(Connection connection, String proName, String proCode)throws SQLException;
    public List<Provider> getProviderList(Connection connection, String proName, String proCode,int currentPageNo, int pageSize)throws SQLException;
    //通过供应商id查找供应商
    public Provider getproviderByid(Connection connection, String id) throws SQLException;
    //修改一个用户的个人信息
    public int modifyProvider(Connection connection,Provider provider) throws SQLException;
    //通过id删除供应商
    public int deleteProviderById(Connection connection, String delId)throws Exception;
    //通过条件查询-供应商表记录数
    public int getProviderCount(Connection connection,String proName,String proCode ) throws SQLException;
}
